load data
 infile 'D:\Userdata\db\contacts.csv'
 into table contacts
 replace
 fields terminated by "," optionally enclosed by '"'
 trailing nullcols
  (cemail char "TRIM (:cemail)", cname char "TRIM (:cname)", cphone char "TRIM (:cphone)", ctitle char "TRIM (:ctitle)", ccomments char "TRIM (:ccomments)", scode char "TRIM (:scode)")
